﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="QLDT_GV" targetNamespace="http://tempuri.org/QLDT_GV.xsd" xmlns:mstns="http://tempuri.org/QLDT_GV.xsd" xmlns="http://tempuri.org/QLDT_GV.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QLDTConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QLDTConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLDT.Properties.Settings.GlobalReference.Default.QLDTConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GIANGVIENTableAdapter" GeneratorDataComponentClassName="GIANGVIENTableAdapter" Name="GIANGVIEN" UserDataComponentName="GIANGVIENTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="QLDTConnectionString (Settings)" DbObjectName="QLDT.dbo.GIANGVIEN" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [GIANGVIEN] WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([MaCN] = @Original_MaCN) AND ((@IsNull_CNBoMon = 1 AND [CNBoMon] IS NULL) OR ([CNBoMon] = @Original_CNBoMon)) AND ((@IsNull_LVCN = 1 AND [LVCN] IS NULL) OR ([LVCN] = @Original_LVCN)) AND ([MaKhoa] = @Original_MaKhoa) AND ((@IsNull_xoa = 1 AND [xoa] IS NULL) OR ([xoa] = @Original_xoa)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNBoMon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNBoMon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CNBoMon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CNBoMon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LVCN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LVCN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LVCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LVCN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaKhoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_xoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="xoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_xoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="xoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [GIANGVIEN] ([MaGV], [TenGV], [DienThoai], [GioiTinh], [Email], [MaCN], [CNBoMon], [LVCN], [MaKhoa], [xoa]) VALUES (@MaGV, @TenGV, @DienThoai, @GioiTinh, @Email, @MaCN, @CNBoMon, @LVCN, @MaKhoa, @xoa);
SELECT MaGV, TenGV, DienThoai, GioiTinh, Email, MaCN, CNBoMon, LVCN, MaKhoa, xoa FROM GIANGVIEN WHERE (MaGV = @MaGV)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CNBoMon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CNBoMon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LVCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LVCN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@xoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="xoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        GIANGVIEN.*
FROM            GIANGVIEN</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [GIANGVIEN] SET [MaGV] = @MaGV, [TenGV] = @TenGV, [DienThoai] = @DienThoai, [GioiTinh] = @GioiTinh, [Email] = @Email, [MaCN] = @MaCN, [CNBoMon] = @CNBoMon, [LVCN] = @LVCN, [MaKhoa] = @MaKhoa, [xoa] = @xoa WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_DienThoai = 1 AND [DienThoai] IS NULL) OR ([DienThoai] = @Original_DienThoai)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([MaCN] = @Original_MaCN) AND ((@IsNull_CNBoMon = 1 AND [CNBoMon] IS NULL) OR ([CNBoMon] = @Original_CNBoMon)) AND ((@IsNull_LVCN = 1 AND [LVCN] IS NULL) OR ([LVCN] = @Original_LVCN)) AND ([MaKhoa] = @Original_MaKhoa) AND ((@IsNull_xoa = 1 AND [xoa] IS NULL) OR ([xoa] = @Original_xoa)));
SELECT MaGV, TenGV, DienThoai, GioiTinh, Email, MaCN, CNBoMon, LVCN, MaKhoa, xoa FROM GIANGVIEN WHERE (MaGV = @MaGV)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CNBoMon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CNBoMon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LVCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LVCN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@xoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="xoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienThoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaCN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNBoMon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNBoMon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CNBoMon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CNBoMon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LVCN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LVCN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LVCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LVCN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaKhoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_xoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="xoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_xoa" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="xoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MaGV" DataSetColumn="MaGV" />
              <Mapping SourceColumn="TenGV" DataSetColumn="TenGV" />
              <Mapping SourceColumn="DienThoai" DataSetColumn="DienThoai" />
              <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="MaCN" DataSetColumn="MaCN" />
              <Mapping SourceColumn="CNBoMon" DataSetColumn="CNBoMon" />
              <Mapping SourceColumn="LVCN" DataSetColumn="LVCN" />
              <Mapping SourceColumn="MaKhoa" DataSetColumn="MaKhoa" />
              <Mapping SourceColumn="xoa" DataSetColumn="xoa" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="QLDTConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [GIANGVIEN] ([MaGV], [TenGV], [DienThoai], [GioiTinh], [Email], [MaCN], [CNBoMon], [LVCN], [MaKhoa], [xoa]) VALUES (@MaGV, @TenGV, @DienThoai, @GioiTinh, @Email, @MaCN, @CNBoMon, @LVCN, @MaKhoa, @xoa);
SELECT MaGV, TenGV, DienThoai, GioiTinh, Email, MaCN, CNBoMon, LVCN, MaKhoa, xoa FROM GIANGVIEN WHERE (MaGV = @MaGV)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="MaGV" ColumnName="MaGV" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TenGV" ColumnName="TenGV" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(40)" DbType="String" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DienThoai" ColumnName="DienThoai" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(15)" DbType="String" Direction="Input" ParameterName="@DienThoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumn="DienThoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="GioiTinh" ColumnName="GioiTinh" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Email" ColumnName="Email" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(40)" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="MaCN" ColumnName="MaCN" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@MaCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="MaCN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CNBoMon" ColumnName="CNBoMon" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(40)" DbType="String" Direction="Input" ParameterName="@CNBoMon" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="CNBoMon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="LVCN" ColumnName="LVCN" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(40)" DbType="String" Direction="Input" ParameterName="@LVCN" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="LVCN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="MaKhoa" ColumnName="MaKhoa" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@MaKhoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="MaKhoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="xoa" ColumnName="xoa" DataSourceName="QLDT.dbo.GIANGVIEN" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@xoa" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="xoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="QLDT_GV" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="QLDT_GV" msprop:Generator_UserDSName="QLDT_GV">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="GIANGVIEN" msprop:Generator_TableClassName="GIANGVIENDataTable" msprop:Generator_TableVarName="tableGIANGVIEN" msprop:Generator_RowChangedName="GIANGVIENRowChanged" msprop:Generator_TablePropName="GIANGVIEN" msprop:Generator_RowDeletingName="GIANGVIENRowDeleting" msprop:Generator_RowChangingName="GIANGVIENRowChanging" msprop:Generator_RowEvHandlerName="GIANGVIENRowChangeEventHandler" msprop:Generator_RowDeletedName="GIANGVIENRowDeleted" msprop:Generator_RowClassName="GIANGVIENRow" msprop:Generator_UserTableName="GIANGVIEN" msprop:Generator_RowEvArgName="GIANGVIENRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MaGV" msprop:Generator_ColumnVarNameInTable="columnMaGV" msprop:Generator_ColumnPropNameInRow="MaGV" msprop:Generator_ColumnPropNameInTable="MaGVColumn" msprop:Generator_UserColumnName="MaGV">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenGV" msprop:Generator_ColumnVarNameInTable="columnTenGV" msprop:Generator_ColumnPropNameInRow="TenGV" msprop:Generator_ColumnPropNameInTable="TenGVColumn" msprop:Generator_UserColumnName="TenGV" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DienThoai" msprop:Generator_ColumnVarNameInTable="columnDienThoai" msprop:Generator_ColumnPropNameInRow="DienThoai" msprop:Generator_ColumnPropNameInTable="DienThoaiColumn" msprop:Generator_UserColumnName="DienThoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" msprop:Generator_UserColumnName="GioiTinh" type="xs:boolean" minOccurs="0" />
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaCN" msprop:Generator_ColumnVarNameInTable="columnMaCN" msprop:Generator_ColumnPropNameInRow="MaCN" msprop:Generator_ColumnPropNameInTable="MaCNColumn" msprop:Generator_UserColumnName="MaCN">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CNBoMon" msprop:Generator_ColumnVarNameInTable="columnCNBoMon" msprop:Generator_ColumnPropNameInRow="CNBoMon" msprop:Generator_ColumnPropNameInTable="CNBoMonColumn" msprop:Generator_UserColumnName="CNBoMon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LVCN" msprop:Generator_ColumnVarNameInTable="columnLVCN" msprop:Generator_ColumnPropNameInRow="LVCN" msprop:Generator_ColumnPropNameInTable="LVCNColumn" msprop:Generator_UserColumnName="LVCN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaKhoa" msprop:Generator_ColumnVarNameInTable="columnMaKhoa" msprop:Generator_ColumnPropNameInRow="MaKhoa" msprop:Generator_ColumnPropNameInTable="MaKhoaColumn" msprop:Generator_UserColumnName="MaKhoa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="xoa" msprop:Generator_ColumnVarNameInTable="columnxoa" msprop:Generator_ColumnPropNameInRow="xoa" msprop:Generator_ColumnPropNameInTable="xoaColumn" msprop:Generator_UserColumnName="xoa" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GIANGVIEN" />
      <xs:field xpath="mstns:MaGV" />
    </xs:unique>
  </xs:element>
</xs:schema>